Market Analysis

This VBA script reads stock tickers and a date from the Excel spreadsheet and inputs them into a REST API call. The REST call pulls stock prices for the date input into the spreadsheet. The script also checks if the inputted date is a weekend, since the Stock Market is not open on weekends, and lets the user know to change the date if it is a weekend. The script will then take that data and fill out the Open and Close cells with their corresponding data from the REST call. It will also calculate whether the stock price increased or decreased by the end of the day and inputs the difference in the proper column. Finally, the script will compare the differences and will input the stock with the highest positive difference in the Top Stock section of the spreadsheet. You can download a copy of the Excel file and VBA script here and try it out for yourself!